UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8KE5BfcF9f1pfoAzmYkDK/m508MyjCfR/nX84sM/6GY='
WHERE
key_id = '531367a3ecb0e63fc5788389683a9b5f32915f877b64b88ea842c6bc21e03601'
AND (
token = '8KE5BfcF9f1pfoAzmYkDK/m508MyjCfR/nX84sM/6GY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)