UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9LoNvfvHzy2vl1bEU0Jm8d59F1hAeFeIqNfMtbKUrzw='
WHERE
key_id = '7de6b9adcf055c4f0f86db128c7edd51f85069d5972e1e7a1b638065582210d5'
AND (
token = '9LoNvfvHzy2vl1bEU0Jm8d59F1hAeFeIqNfMtbKUrzw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)