UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lS4fi8TJag1zdF29gg6Xb4/JhosOlOhrXCmor2Kw/u0='
WHERE
key_id = '97c68333f5dc01a24663f0af0c0c260389ca9beb0db425310bb9e09654a7623e'
AND (
token = 'lS4fi8TJag1zdF29gg6Xb4/JhosOlOhrXCmor2Kw/u0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)