UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3KJ1X6IW92r/PZ4kHgt4Lvh9T7qwbs09zlUBCKUONis='
WHERE
key_id = 'ae859ed7689af775fbf930c030b71668abe230b57a20c45d18d600a6cfd55d1d'
AND (
token = '3KJ1X6IW92r/PZ4kHgt4Lvh9T7qwbs09zlUBCKUONis='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)