UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'btyHfJ0FgKNWR+1MrXpz0N48GxTrUqwIWuL5ii5E6Mc='
WHERE
key_id = '5d49d12e2546bbcb625ec2aff7b6a1f74fd61f8477ad3acd7aa747c6f704948d'
AND (
token = 'btyHfJ0FgKNWR+1MrXpz0N48GxTrUqwIWuL5ii5E6Mc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)