UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uMRCi6fAD8mg3cYYv5KCW5x3ctiqfkHLtlDoky9zQKA='
WHERE
key_id = '31b60a9c93290794d0643eebb6a7ca342e6ef106ebf577640263cb69ed47b600'
AND (
token = 'uMRCi6fAD8mg3cYYv5KCW5x3ctiqfkHLtlDoky9zQKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)