UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V7AJyysBb/UUE8rOpubLwqiPh33RgVtujD10bRmflSw='
WHERE
key_id = 'fdbc2f1bf40fb786e00300989e1b2d2f543256ffb8e5123eb3925277f175caa2'
AND (
token = 'V7AJyysBb/UUE8rOpubLwqiPh33RgVtujD10bRmflSw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)