UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gT6oPDdTAAGt+0bSSR55x/+VcGIHQMVEhllSahoayPw='
WHERE
key_id = 'e7e0eb395d2500dd2f62095e6c45740ea43247d003214b573c727ee04717b475'
AND (
token = 'gT6oPDdTAAGt+0bSSR55x/+VcGIHQMVEhllSahoayPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)