UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z99rAxJKRm0KId/TzULpSCSVp3vvGHDm/+pKAsVby4k='
WHERE
key_id = '9727f4bf52263f52e85458e9822933703a039c0eef31ccb8cd1c9c29304d16a0'
AND (
token = 'z99rAxJKRm0KId/TzULpSCSVp3vvGHDm/+pKAsVby4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)