UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x3OW0otnXgJEb6YlXrbQHHYqTOAK3cvhjfhkl0wJEd8='
WHERE
key_id = '8d97f181a237819ea2c8a8db905bbcf8a39af3fa214356ce22e38086a7c36b54'
AND (
token = 'x3OW0otnXgJEb6YlXrbQHHYqTOAK3cvhjfhkl0wJEd8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)