UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5GPW2WqM0J4Grl/zbknBiTwlBUJF/yRyjJ9aYbfPar4='
WHERE
key_id = '31114e956b871f2b7b5bcddf0c7ddf771d3c1167850148843cf2fea3946fdd8b'
AND (
token = '5GPW2WqM0J4Grl/zbknBiTwlBUJF/yRyjJ9aYbfPar4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)