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