UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z1AOzdq2/Lq0OB4h9vGPnbIwlWsmPGwwW6lfIrZuc+A='
WHERE
key_id = '4dfe338e4b4b75ce61d1c14469632d8cf82703d67eabb8d7dfbda35134d036cc'
AND (
token = 'z1AOzdq2/Lq0OB4h9vGPnbIwlWsmPGwwW6lfIrZuc+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)