UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1zS1nuo2i0LzMW9jzJTpKaGqsX0G0WdA/jpZW53XQAc='
WHERE
key_id = '781c6c95fb69cc7baaa354de97f0884efe8ae5a32833a2022a3fa13a1e6ea0c5'
AND (
token = '1zS1nuo2i0LzMW9jzJTpKaGqsX0G0WdA/jpZW53XQAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)