UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Ci1ZDyiKNxRw/IYV9rdPsrc2SgSp1dLVvBoaDoPWFg='
WHERE
key_id = 'b27fb0b99364c5763b33e90a890eb923b3e9119cd889041dbe8680282986d3d7'
AND (
token = '6Ci1ZDyiKNxRw/IYV9rdPsrc2SgSp1dLVvBoaDoPWFg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)