UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9NoQ5tcZYHBXhW0GH3m47Qq04mvr9Ef1it2YrpX0mIQ='
WHERE
key_id = '3cb52bb0eaa587ae562658cad2525cd0e6bede435c822312df519740d2c0caac'
AND (
token = '9NoQ5tcZYHBXhW0GH3m47Qq04mvr9Ef1it2YrpX0mIQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)