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