UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aP08WzhELgNyRGBOsEMWFeAnPseAeTHRti4QG9oi6L4='
WHERE
key_id = '6afb9d528260b326f370aaaa451005f723e78aca7c80911d93ab205d402f6995'
AND (
token = 'aP08WzhELgNyRGBOsEMWFeAnPseAeTHRti4QG9oi6L4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)