UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zpNHKzmt3xUAkABpuSb0VV0ew8+aOaarn5vst0R5w+U='
WHERE
key_id = 'a06829b42f08d26a95a51e408091bacb5b54119e380d042b88b1cff42c5eef76'
AND (
token = 'zpNHKzmt3xUAkABpuSb0VV0ew8+aOaarn5vst0R5w+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)