UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/7CUp/HSyAhmwyGpRhBcwUbHuDhD7DUbLgmgJW0s0KA='
WHERE
key_id = 'c852df00d2fa64ff2ae8f80ed98bb8c5ed1d8e8eb3e711183111e834809a0df1'
AND (
token = '/7CUp/HSyAhmwyGpRhBcwUbHuDhD7DUbLgmgJW0s0KA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)