UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '46ZNs58a8RUc9/n8WrMMYFc2cQQ9TZqw3nmqL/0n+0A='
WHERE
key_id = 'b1bf449c9bd14b6c61f22ef7b30ad52079de1555781a1541b2ea047ade07931f'
AND (
token = '46ZNs58a8RUc9/n8WrMMYFc2cQQ9TZqw3nmqL/0n+0A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)