UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hnt/RZM7k07izNPi2M1urOaHI2PisXu8VBw9wUkyTh4='
WHERE
key_id = 'eaea37a1c30631a6951026775716ca92467f2919ac7db1b16d8ed278b3584672'
AND (
token = 'hnt/RZM7k07izNPi2M1urOaHI2PisXu8VBw9wUkyTh4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)