UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X8LbzxsGr0N0CGAcCibpXW171x5oPukSDeEqd952Xjg='
WHERE
key_id = '10ff7715a5c6ad2989b753f3e84122ab039b73c9a03f6bc96f38d3894368034d'
AND (
token = 'X8LbzxsGr0N0CGAcCibpXW171x5oPukSDeEqd952Xjg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)