UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N2pf1N8mwUhy4fnp6+Kx5miH3KXNMUp5aZBULMHVEo4='
WHERE
key_id = 'd5bfc912e1a729b765813ba3ddae6099a312ecc94e3a6bb0ba9fdc43ad3e1817'
AND (
token = 'N2pf1N8mwUhy4fnp6+Kx5miH3KXNMUp5aZBULMHVEo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)