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