UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CnXiqrMZAO/v/u5HI3yP7JUthCgKjn5fjb5YPxRetHs='
WHERE
key_id = 'b8793de5c7497b2bfe921bda23398aceebafec18d70642998e0a06b851ed0b3d'
AND (
token = 'CnXiqrMZAO/v/u5HI3yP7JUthCgKjn5fjb5YPxRetHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)