UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9+rC3NgpXPVk9Euxt8BVBvn75mas2vIcvpHDOoeUoKU='
WHERE
key_id = 'b0cfffd5e3b3895249236157f74ad3cc635a8525ace569a1067a2eade2c5ce2e'
AND (
token = '9+rC3NgpXPVk9Euxt8BVBvn75mas2vIcvpHDOoeUoKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)