UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EKkX7dO0sseir71DCnC3hABcEJ6OBYeyh7oSBjjO3PU='
WHERE
key_id = '0cfb0e34be1fddb7634c381f73f1f6bfc6257b1faf1de3440564342ab3580f6e'
AND (
token = 'EKkX7dO0sseir71DCnC3hABcEJ6OBYeyh7oSBjjO3PU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)