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