UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SMcg9tH1G09RVHFvd7Yaabvmgcack5qwEgQMKCe6FnI='
WHERE
key_id = 'a80a7050b2918048c826f4b5abdaaa9d3a2aaf13ffd87ddb9837f8eabfa69284'
AND (
token = 'SMcg9tH1G09RVHFvd7Yaabvmgcack5qwEgQMKCe6FnI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)