UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ROV4jnfbRYEG4ROzrymJj2f6wKxW3k8JiLqvj/QAPfo='
WHERE
key_id = '46465c0d167bc9d1ef29507f8def9d02e63b4cc55dfbaec11d9bcd1c4f7a3f5e'
AND (
token = 'ROV4jnfbRYEG4ROzrymJj2f6wKxW3k8JiLqvj/QAPfo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)