UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rgtKRE7Qxg4df3JtZv8tQd/ZXLWiAUV7SFoTwOVO09k='
WHERE
key_id = 'e23fe95bdf361551c4fa26772a4be17c8c1c4673833dcf198cec3e8820e2bc83'
AND (
token = 'rgtKRE7Qxg4df3JtZv8tQd/ZXLWiAUV7SFoTwOVO09k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)