UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QNfg63PiTPD+Y808d/CPEmf0OAbXfTfxI8h7MWb+tf0='
WHERE
key_id = '4e655b1e4ac24f8d7d4d8018a30e622cb0d11ca7ea5d04b36d12efcc1b74bb73'
AND (
token = 'QNfg63PiTPD+Y808d/CPEmf0OAbXfTfxI8h7MWb+tf0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)