UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'doJg9UiqHTBPCcHbBusUYzTGFwL6DoH1hEw+SlRHU70='
WHERE
key_id = '9de2066172e79fccbdfbe4dabb204c3c8df782ffcd7785dce00577f81dd2ee10'
AND (
token = 'doJg9UiqHTBPCcHbBusUYzTGFwL6DoH1hEw+SlRHU70='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)