UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Kx+bzNTok0Vk6ySrW64iON1dhz2kwfcah+r8+bybvXI='
WHERE
key_id = 'c14b6dc9043b7bedcff10c18cc43f888ee1e7fb436cedd382da8795ab1225bc5'
AND (
token = 'Kx+bzNTok0Vk6ySrW64iON1dhz2kwfcah+r8+bybvXI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)