UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZwkHTz9/+sEiN1LWYyvPBwIRPZcdu7gJGLPpWz0WNdc='
WHERE
key_id = 'a015ffaa949251d71d792ad22409c65d9b38342bed1e5e6f0217e207bc16e540'
AND (
token = 'ZwkHTz9/+sEiN1LWYyvPBwIRPZcdu7gJGLPpWz0WNdc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)