UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z70QiwRzjkAACT2DOLavOhNzo/VWaA+AG+3rhBaMgGo='
WHERE
key_id = 'c59028651849d6344af482c84da0e0aa9847955a92756312f836a6cb91aee775'
AND (
token = 'z70QiwRzjkAACT2DOLavOhNzo/VWaA+AG+3rhBaMgGo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)