UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9+PrKbeaizRUaUgMBckAbXv+3FooPVlx0YCQduOZ6Hw='
WHERE
key_id = '70942e59e9f81f88384e3921ade1dfc15b519c6767f3ad71af08e141082e765d'
AND (
token = '9+PrKbeaizRUaUgMBckAbXv+3FooPVlx0YCQduOZ6Hw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)