UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7iq6ze6ksEsZyHupjxF1wN0va2bzOsav8FUHALVom0s='
WHERE
key_id = '6256eb8f65ad0580580411c29e888b1fdaccea1ef584a01b75eb67ff50ea6955'
AND (
token = '7iq6ze6ksEsZyHupjxF1wN0va2bzOsav8FUHALVom0s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)