UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2BgL8jo3Xf8BpTuzcfvhOX0w5ebF+QJNvG1dG8/Ze+A='
WHERE
key_id = '504a8f1c8b43917399c71d3d94b84a797e60599957d9d78ecea2ec62ef91ca6a'
AND (
token = '2BgL8jo3Xf8BpTuzcfvhOX0w5ebF+QJNvG1dG8/Ze+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)