UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0yG6lMW2TNlfHnRQCNKNN3xIVzZduzlHOlfR9XliLXg=' 
WHERE 
  key_id = '40b4a4755a73a45f486437a08b63e9f5f25d09dedf5efe54fb06939906979609' 
  AND (
    token = '0yG6lMW2TNlfHnRQCNKNN3xIVzZduzlHOlfR9XliLXg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027