UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/d2THW8hfQ7+gwNsc1qqEkiwSANsKKT691koqIzEedM='
WHERE
key_id = 'f67d468df23daee4600101a186e8f974e5e94f9a8672ee922bd880019b5d854b'
AND (
token = '/d2THW8hfQ7+gwNsc1qqEkiwSANsKKT691koqIzEedM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)