UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HOhSCz8idDhoe7kd5TF3/5B0u2f9TR2zW08l+mCfoc4='
WHERE
key_id = 'da5d7a5caa2bfb8471bdcc52a7a10bd1b5b2c6506edb3e7ab3b8ec2b4ee33cd5'
AND (
token = 'HOhSCz8idDhoe7kd5TF3/5B0u2f9TR2zW08l+mCfoc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)