UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9yNYxBGOzVuJxA7sLKnwXks6ybnHz6fKvBbw19Dqang='
WHERE
key_id = '52940e505c54ebcd8010964c8aa521e72f39485e4a488636997655bb69ed914f'
AND (
token = '9yNYxBGOzVuJxA7sLKnwXks6ybnHz6fKvBbw19Dqang='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)