UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C8lR2Jn4oimWA5z1uCossm009q7cWR6I3IO3iVR9Xz0='
WHERE
key_id = 'e0ac05327c604994b4464ec026bc6d7a0af2682abdc574d4cca3b3aa28d3b460'
AND (
token = 'C8lR2Jn4oimWA5z1uCossm009q7cWR6I3IO3iVR9Xz0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)