UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hn9ivJhvVIEL4I10tcOiYpONsQRJbcliOV7mFxu8Ruw='
WHERE
key_id = 'c287fd11d8448391c58da8ffa614ca92bb8638281f0f9a2915777bd4c7e0b1e9'
AND (
token = 'hn9ivJhvVIEL4I10tcOiYpONsQRJbcliOV7mFxu8Ruw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)